SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664311 LIMIT 1 [ RunTime:0.001555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664311 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783638,676352,974169,622734,145593,534269,246574,754779,324774,94457,921728,683499,258383,139999,16502,858813,116444,1039304,980014,766096,25779,483144,399952,433612,322688,100974,428433,2706,9531,828506,400401,121208,623354,470323,519169,107104,488123,585680,263710,401260,43151,630832,815317,764098,1014749,45244,445512,168570,986294,651578,552672,321378,238261,40387,510419,874711,425217,905947,378215,25599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001216s ]