SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549568 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549568 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509012,569913,402433,758240,760452,227510,146383,410051,804751,944845,264236,667105,170960,273517,658138,764650,470517,986915,316972,801466,91686,914077,751862,658137,695088,378827,839657,157838,531490,527844,499095,197475,24505,425931,1030451,189380,876457,500454,959784,473941,756888,72025,884242,263671,990119,386426,747754,779721,531207,453070,709499,157647,304914,76776,802538,464014,480875,1036730,767513,818157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]