SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524317 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524317 [ RunTime:0.006182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205461,646398,1038685,1016940,426964,745365,463111,794237,856688,530168,1031304,92698,983441,648191,924778,205032,911027,242567,134834,13983,267806,202987,956614,584610,311786,117869,978549,863433,60337,841280,308772,1009907,940128,224110,178176,809358,163046,469661,159250,421104,569516,99403,592005,212451,904218,438227,443045,371115,424305,418170,322694,523999,326700,672270,893,525753,153246,793294,496007,553921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001970s ]