SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5359 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5359 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780088,401370,472046,794669,79148,770513,633868,155453,1036352,777652,372219,66156,985457,961093,615503,270727,845304,344701,872396,598176,629698,802663,566748,13555,184173,266732,325924,1011245,373294,214423,11506,979131,623149,367665,567804,186550,549162,818591,828528,332324,432746,890177,444037,109602,231166,91677,155159,402782,12709,535781,398913,800162,462018,155872,507698,1030373,956230,189238,102915,731260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5359 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5359 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001710s ]