SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020966 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020966 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101586,625746,644307,107892,327418,598682,302348,347142,728277,918364,582310,34562,675610,443781,11620,305717,790334,469922,982626,576129,174020,1031675,485112,536361,611728,8228,167737,985020,892675,402826,130996,126784,216067,538651,233858,934048,693959,690193,597546,683134,41859,526745,602175,523936,771177,93200,124068,261646,471253,478416,388535,776922,80305,1035372,63200,838625,836335,265158,170147,781949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]