SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50139 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50139 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541684,120572,445463,53657,398109,15339,652913,392762,605065,745649,87168,109814,457366,392652,474807,239756,212659,272678,792582,527779,882497,100260,9276,477433,561866,485139,621730,587741,216458,514595,589529,528064,53183,1047812,118914,493525,487580,285759,237622,896363,970692,742865,876778,1044787,48260,1030738,947765,55749,249816,145256,765179,224688,910510,1004864,181946,641529,820443,210602,696193,234284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]