SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584218 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584218 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727569,331280,699898,412927,801266,753777,961012,103068,608083,674016,64859,440995,836040,137582,88283,1002607,1045944,936674,472543,783378,824521,428705,473393,670235,562860,76096,640889,428861,650945,574563,202829,182829,567683,851669,752630,1039198,1043544,497707,251828,67051,956991,423105,435873,228250,1023049,812111,803436,342695,555207,430075,867725,810997,969307,588486,677542,389074,525708,521086,894819,294700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003477s ]