SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292896 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292896 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021218,393284,530701,261823,712699,816400,976494,518822,933301,337530,914154,214886,107944,253492,776074,941759,194313,202422,459885,778836,290723,755764,683229,900610,925676,1029496,369303,346646,872165,385463,408019,404787,242814,803898,212732,522052,352944,84080,106620,50717,923954,932077,26404,616962,237744,444463,754916,944295,304910,675731,383799,32476,959902,530372,55521,448143,292955,172202,536715,685119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]