SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471614 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471614 [ RunTime:0.004561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393585,129486,387979,244437,43621,2704,675268,204772,236958,299820,748845,272538,425216,707205,433072,40585,946474,422970,561718,734453,39297,863190,859629,695603,597957,1031472,505953,502803,507694,1034643,146756,659577,432255,741024,149040,554468,160189,588806,564209,515236,915398,483673,173998,354857,148879,504812,268019,523087,707896,778556,1010913,785985,165213,513010,191632,606063,749034,587224,233954,578427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]