SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534290 LIMIT 1 [ RunTime:0.002283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534290 [ RunTime:0.005814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868291,524253,202677,164214,194455,188230,380673,10564,122548,570879,303154,1015345,1020641,718699,431068,982376,620501,7382,301381,630822,267115,1009945,974945,652830,408834,780775,874445,258117,300434,604965,135301,457724,423018,498366,806557,961596,904855,1000353,348605,335267,1024877,365093,949246,432433,65373,440154,960372,41316,914513,673983,533447,229201,668689,83325,759877,767732,971991,842045,500949,831923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]