SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431509 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431509 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983022,263152,575884,620115,1048842,99088,485475,24075,276819,384375,912317,516879,513004,1004516,799645,54390,622194,702455,596306,375987,219769,418626,1005020,801301,179021,242383,934766,461259,548550,399183,648301,934040,638483,37428,250461,930986,171569,59784,341414,672902,62038,542639,847984,641285,672669,415770,159392,537979,191231,9801,36234,84582,42882,175975,1000455,416901,885660,174906,312640,704987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]