SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 648650 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 648650 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560710,616685,256663,7718,11313,646233,681906,82474,859366,444430,921348,732005,617425,233671,540656,151685,729825,459812,53742,522032,828042,633981,441036,327366,602906,124257,774522,488860,780058,551617,720874,865588,64499,217819,851846,747383,641467,341960,705986,141533,923409,69009,181884,20955,501936,765993,781454,320272,808456,898596,997546,542191,619491,580554,292579,385840,890156,633074,485303,287751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 648650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 648650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]