SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472000 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472000 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664860,333632,863485,555876,586515,870798,229728,731792,288596,184418,1039740,486030,316084,35951,145881,602931,307994,727669,613293,537500,300660,790425,971775,160152,1020349,287802,375344,1023475,199559,291954,356424,622723,368151,662617,242157,659871,1021838,233456,51080,863530,8029,248652,125414,957157,954354,36391,417617,459871,519721,1035801,574054,309356,855815,347630,522006,260999,442184,174826,922025,867071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]