SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269826 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269826 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808618,616943,570377,29584,732783,500238,381471,107973,468346,197830,43891,184568,1023455,825143,343522,140628,1034287,755141,209380,243159,1027245,917701,358308,534817,939834,297671,515066,86548,850141,862652,839485,21593,122793,1023045,593244,418251,1018863,1034324,556913,118172,538875,312689,783475,1043953,241872,526116,325695,1026653,123526,97457,741844,776958,665122,965882,483832,644882,110007,483419,270660,167788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]