SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982003 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982003 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937112,148931,873698,1038252,105102,21056,201618,382119,862882,326253,1026216,1016775,906424,681192,30559,839088,344433,259322,1028405,676370,4316,348933,641338,601339,1004867,47773,276377,335529,209266,764197,68101,550814,382031,987726,271198,310904,364637,949350,458841,376047,570586,332102,340020,244276,646137,267618,818609,301412,873806,558704,634524,984912,234618,888038,567375,4304,430605,714604,766000,104118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]