SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548457 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548457 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513390,761143,530032,238217,943866,963021,44185,900388,938600,1037979,66435,471520,615831,27520,1035029,337749,162329,1011251,649781,993122,404973,474354,661270,395449,214535,66950,965743,179599,681031,503045,440891,811007,927032,992903,58684,367217,188608,760606,1006006,40168,62117,599468,726891,505998,628077,311894,101212,193351,798439,136331,993300,734310,636008,814750,247850,468464,638953,360747,245590,144268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]