SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466085 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466085 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839601,39892,38621,898073,832560,805994,747229,801791,354227,771950,436899,446809,459827,950594,597620,251654,163533,50974,841364,667512,55868,678442,723292,109993,310963,436575,821949,512721,9165,627257,965067,118511,653914,418161,747518,898244,671964,396036,820612,118229,147282,861363,96738,154707,538431,64487,134551,89670,107414,497672,844360,175123,11854,528930,146869,205869,724890,767787,979191,150941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]