SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247613 LIMIT 1 [ RunTime:0.000897s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247613 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877582,397042,1008364,934571,718823,255220,156764,385561,718216,348409,380082,567531,464170,252355,879107,783257,703860,773953,740201,105959,642307,390548,875254,857944,15603,822072,875551,648948,88130,1033491,372498,982450,578821,999875,1008661,1026041,536201,986841,894165,97548,781856,1017755,943189,500529,219864,650556,463753,831682,483341,172709,202779,847454,338418,874465,25669,136640,974200,638470,257776,706690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]