SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620096 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620096 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464518,191819,538133,505008,844756,775776,589651,535640,375341,842797,676419,709773,785704,165673,934335,1004468,264525,272453,719405,288710,82449,435979,422809,332561,392706,546831,766986,156659,427080,972318,769759,458590,197322,322176,1002004,237430,112861,794887,305306,518827,771772,691640,171426,472633,92825,566863,738983,742100,354341,347763,365031,1007623,132430,346826,844388,124533,333173,12415,103251,611792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]