SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489010 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489010 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6830,737417,603159,311985,947458,274781,140949,968599,71070,266850,472470,136859,56104,27925,765884,358580,491016,1044108,878831,26730,384605,861400,330476,964384,1011249,385077,813397,310875,1033777,757560,931950,380132,305644,1025616,353770,769026,801093,392059,1045629,504018,796236,992881,215255,27222,985272,498033,366065,67028,36796,1038246,114884,24185,665474,672507,586731,66625,324054,648542,800980,291532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]