SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500113 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500113 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925109,501637,72800,779793,813488,952488,1014098,29684,9074,237761,247926,234829,148194,405355,264306,376642,6909,285166,863539,521076,784069,23690,264995,679496,759599,165932,658406,938626,277975,234572,208518,708504,984654,933903,837794,572477,866442,896245,568301,640018,203178,266618,840600,887465,54943,420775,804699,370618,1362,122969,479280,388517,583095,860161,118458,535258,95887,61975,56528,583665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]