SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542751 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542751 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740625,111428,450087,629379,976111,133004,981769,919875,484578,2842,177910,518307,382543,648578,308757,298622,951087,505505,219102,147347,813012,118017,387621,436210,844456,523084,641370,453135,856274,46769,258899,114163,734921,929272,321501,1039850,834653,943197,499963,301021,723688,1034087,564095,971223,289984,354426,477451,901428,592881,211872,419018,301630,582380,730817,925984,285937,1027115,359594,736903,804018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]