SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584470 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584470 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822921,113115,335185,490334,795684,890082,950171,759028,856031,344486,144837,997710,459541,187558,676901,42976,131678,855593,1014029,745012,562032,51415,490153,293513,606599,802326,185708,240668,198405,543543,43937,542752,16638,339472,826894,648325,100825,531907,513663,1019142,1023254,14890,115492,488716,984387,821918,582478,357477,589636,606655,458009,440183,238155,494086,589958,837860,476553,531561,108459,621501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]