SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431096 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431096 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371448,1002280,638240,669973,371421,20043,99632,956977,531155,755104,420674,393368,300305,1012763,219329,764268,1016430,966847,663215,263196,409069,630360,701952,757556,856091,1044713,366473,515194,420165,480032,329713,274646,181193,648983,901083,675907,858462,144274,731044,972279,770455,119661,1038975,281815,362800,161695,902561,464305,772906,172994,908371,35522,352736,794401,709507,649011,955187,79872,182898,655284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001688s ]