SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511541 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511541 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898804,841527,480821,731415,556929,346335,487497,423691,266947,437377,610586,912639,224740,149086,600930,218847,931929,305305,870113,471921,304593,1022580,157126,716006,407138,463709,676717,349009,301266,861689,384356,216370,60965,325766,947027,840972,479393,979186,165638,801862,762513,773082,344810,584186,743853,974722,803790,728013,241874,371211,428386,75893,190627,927147,537009,250742,480843,561973,894280,433260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000777s ]