SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377964 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377964 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504065,545026,204098,542236,7798,674374,75957,359148,453593,387149,911068,972178,161438,653970,630026,325059,499950,552724,676089,112830,307446,264115,486200,229264,157674,501400,268334,285640,149882,99869,894759,7172,795758,690488,797209,580568,413880,438400,724065,1029890,273911,388135,319823,959365,148767,725103,72991,57188,453951,991628,300481,521493,627606,598321,578269,313483,927722,466193,399117,464958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]