SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003254 LIMIT 1 [ RunTime:0.003893s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003254 [ RunTime:0.009838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016440,457484,643944,895377,92170,720478,1020097,136432,144159,524552,459684,37314,173132,381091,762951,578099,87213,167239,274040,379883,641042,161443,263331,353533,887831,913470,703475,344714,34956,964774,1015327,214845,940125,387463,897358,440819,933889,901142,183329,225843,1011433,468079,381088,994843,647195,185916,682015,866382,811443,685507,131884,894129,313078,84007,526105,324063,661392,523711,636468,1024957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006925s ]