SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245404 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245404 [ RunTime:0.003185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418440,780631,1042828,720359,681828,155963,120483,887584,669420,584106,917250,505708,845522,172670,906883,321001,682088,220061,788825,133195,843545,631517,880860,986572,962787,21206,882785,686821,282361,635582,306944,565323,903448,470839,777308,518285,185468,479271,982200,913450,1015718,108546,736872,695532,662635,196894,61371,771311,870914,855691,197672,761436,631612,350268,3810,603545,356592,503454,302111,768596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004874s ]