SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449084 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449084 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (944040,396189,497985,432312,705929,651844,272448,585779,270101,371530,433575,468703,697516,337585,542105,513600,826702,36487,945639,505104,216703,239749,417590,556950,294822,586059,70837,810237,352790,428634,440534,350388,820559,1031446,336435,37789,710365,134564,405201,789420,789207,890528,649655,431550,857060,568760,649555,964481,830852,979487,182662,698984,133067,604557,634102,98112,222249,701946,643327,66248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]