SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199903 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199903 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43168,153819,318527,884452,488806,733866,594675,1031892,765163,678894,111487,846698,755663,1048696,214350,758627,214476,734927,552331,941054,730278,219078,1012930,361247,507904,330311,283093,917293,250784,671065,104241,472823,431107,920627,517911,73394,507669,782042,838067,841413,670655,674693,642166,471653,361438,991319,89836,773713,755707,125020,117863,661497,792860,736514,23548,900007,151911,3911,129430,11601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]