SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984712 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984712 [ RunTime:0.003950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508433,979462,939007,728081,313141,233039,750679,254995,980062,579635,513845,433937,37758,49022,349086,852670,162487,301972,247086,718496,433307,960291,481340,300315,893975,831633,791907,376806,507308,262048,115955,425116,622181,610019,704832,767265,537772,311415,538187,429490,741386,404136,128620,916034,199354,963449,871679,992115,567652,294950,987272,476972,777469,371500,805214,662391,828491,103780,611104,218992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001114s ]