SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010460 LIMIT 1 [ RunTime:0.003092s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010460 [ RunTime:0.003148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972791,726499,920697,635460,113601,79513,231521,522131,203137,727281,553092,430716,481915,946106,149934,257371,259819,518075,577952,736664,206098,2200,890091,509756,425164,36549,727350,698219,1022806,332098,615419,995225,435205,261788,994476,167635,906191,198084,5188,310191,254039,723926,691627,392815,307907,220001,18838,607108,757776,862665,107660,799824,845721,538453,1045322,728922,974766,415224,857835,676168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]