SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004041 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004041 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421504,198844,371556,63667,325506,541036,493933,144010,435866,123995,676980,691906,913611,950008,852808,927517,611154,890628,188241,916490,852248,220232,306080,884174,1001203,677867,186704,423628,469072,669503,194380,847799,1026923,978820,873804,1026668,316732,529883,858454,857402,660431,515588,525480,562011,159929,910384,749602,253647,784368,423758,710997,1039334,680474,276570,839851,318285,442375,440445,115098,829973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]