SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008240 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008240 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250982,110660,1045198,748187,630540,461909,342806,604851,979950,668169,903471,707111,41398,843787,522158,402428,454627,543284,805400,1002213,394377,984741,76867,320674,176290,410599,50380,550740,1048562,624841,847268,858746,981843,907706,980268,112272,477362,911985,634461,1004673,744271,64204,92542,722757,332390,951671,917721,8046,737907,152586,461881,706414,41369,293674,187592,756118,880117,724276,420107,524600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]