SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100134 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100134 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61144,627838,324523,462051,753077,681514,253830,1007604,739020,993546,359012,1014346,719126,199998,912180,258790,763522,520266,551740,781540,209230,164046,934936,162827,396581,536279,346961,450593,75382,215698,273201,883513,187838,22109,766929,378018,699174,933782,883371,154613,376959,951567,36309,897316,986819,43073,559700,173789,14874,168174,1000512,541208,331672,633140,801678,803593,424892,847968,724683,746603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]