SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98102 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98102 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387049,956763,190101,465347,759293,283529,660708,691464,46498,771639,772032,90481,974908,147180,838409,1035363,749130,474853,186654,509236,888101,431424,851259,1040620,45971,154884,239589,869499,675484,223655,51302,25147,359705,320820,157260,607248,912298,93991,868748,838623,260004,168433,21805,180728,819055,59180,424610,19532,530813,898336,35537,41614,184551,847686,81830,451471,39522,881687,666463,72586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]