SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518741 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518741 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020049,937335,747069,465743,106801,682562,58524,669496,642852,277743,422904,483639,767748,528484,322264,896227,325300,765829,830684,100182,840291,511180,989698,545112,126790,666920,365833,340617,464928,241090,305206,295736,667485,599914,143542,487080,687763,691870,4383,109171,275287,777117,862717,604822,201332,147093,722645,296589,519684,48648,750831,660108,532090,18626,317442,1031327,315445,827882,470679,746978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001078s ]