SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.011092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430423 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430423 [ RunTime:0.005110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747776,271069,989372,97532,781281,400218,999044,501413,881166,429931,240148,770087,817908,129192,478447,574372,777188,657752,78163,718224,869433,754432,820022,574690,553492,310094,1048167,369023,692646,465530,8112,466407,804287,785843,458098,536590,326247,998613,262622,518962,517892,633770,646678,77976,983570,551486,308074,1023592,1024376,101611,551095,366801,201811,284637,969835,485687,359781,732372,793661,528254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]