SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534608 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534608 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533510,395992,672372,491177,726015,208519,272311,505250,278782,470728,799671,911073,645357,345314,840101,766963,635152,158232,487644,871874,424910,741846,789552,298771,250166,583544,757095,391321,43123,833465,232942,33941,848665,997787,681631,920112,5375,217939,464064,800418,437198,294221,689552,770554,38062,977007,773037,628297,130948,497557,53466,1006443,408964,925087,452446,31668,989538,45885,19498,912642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]