SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538046 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538046 [ RunTime:0.002916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801319,272576,173392,823863,155520,648797,314818,835427,642238,652379,49698,467245,720754,554421,785486,395499,583323,494184,165609,2166,237070,935911,4265,411715,1044413,365906,211939,843093,1034336,780835,105797,365817,203469,932962,701594,828055,777561,29831,255606,142931,473833,532183,156425,410593,836409,516936,38612,695558,1002938,987918,57113,28693,937043,569586,333493,449301,339566,882809,741876,101831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]