SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045307 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045307 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595502,534541,221660,310202,954707,299585,544331,200018,909134,241148,545868,533120,842489,937799,431052,746720,892595,895261,849385,1047784,617426,556200,611004,192233,1026712,781292,693337,422393,904628,43704,814682,133709,866270,425878,9955,451968,870581,67510,411084,566095,178107,234837,367175,482217,885122,444994,226294,472434,322657,697639,263009,742996,537719,1047392,733460,811571,781870,651945,82779,231661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]