SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531001 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531001 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131370,538803,661181,286881,610865,791448,295273,613458,187989,901507,432042,129562,977393,476896,686307,589879,997996,566041,938537,21441,215383,615461,312364,324577,839555,409859,685666,558983,418951,709738,154562,760781,718297,679941,60961,1034847,716922,990980,41163,413720,93427,90464,899808,677116,619284,39187,46588,923135,108586,1042057,260692,324483,989948,491172,21552,535544,855243,324465,886040,649032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]