SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004828s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570028 LIMIT 1 [ RunTime:0.005107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570028 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801369,586908,1047435,463541,383588,103118,889477,276049,832673,990325,508692,34348,101063,428454,374246,944606,928162,565804,38189,273861,28308,443524,507887,544147,673878,109836,222711,864702,231580,736924,397012,472781,243631,451294,863168,829313,623367,171092,350364,727043,932025,631777,343442,310907,861153,729397,972020,263898,735604,294295,79802,679668,399860,399170,453278,239460,657251,883303,661501,292289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]