SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335843 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335843 [ RunTime:0.004762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742939,125666,1007699,528947,316829,1026559,195409,271796,286656,598879,89455,618339,569974,217699,754353,65664,96515,1023879,881363,984114,173672,578036,211361,647192,108731,463777,79883,120436,740756,510966,736314,989908,585870,831956,992445,505535,357305,265941,606696,637959,453179,139018,260763,418036,142219,478075,906127,868515,495542,300624,91876,614470,575707,632336,686672,598246,759697,6850,337102,339660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]