SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544571 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544571 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159909,988177,941353,876855,456376,38001,986935,632701,120365,597889,809177,755384,750890,243321,755006,269799,988975,53892,598054,576399,833878,187163,308067,772220,743096,48290,932469,688961,151586,7632,302811,91742,23604,514691,807618,572572,707808,490571,753,114254,349233,931340,100769,539673,230891,179278,442632,182671,803250,46897,421266,392129,378409,66904,780416,472795,302153,391564,849941,375778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]