SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565563 LIMIT 1 [ RunTime:0.001527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565563 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44153,479087,198752,883828,367874,169042,981795,648362,284520,674599,481007,141956,883310,168469,170465,1014428,70171,302429,256799,1016146,689148,611756,238557,441738,665124,864641,251738,19026,406534,532985,162271,640321,126573,958094,535112,553433,42261,422689,234912,409814,717651,198426,533500,499470,777562,312056,236844,352660,352246,802385,352300,575945,260170,312547,645013,1047157,827927,241284,1001420,42091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001566s ]