SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105251 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105251 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366917,265759,367862,176027,367302,291503,523751,199325,137265,340661,470111,277968,1033614,1003617,513502,325136,823269,862747,76086,1019309,231579,1030654,540592,760827,935481,524557,276681,443185,861466,750328,550391,97035,86019,1025052,908856,358444,70792,257520,508090,64150,835423,662497,250573,649206,388776,186904,914839,264340,452736,51964,913152,369850,985362,483378,698778,394758,300313,136059,308169,633947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]