SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429170 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429170 [ RunTime:0.002744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807295,520232,209377,202557,1043520,415275,441270,564100,309895,66792,309056,12341,991636,714779,404660,549133,238443,913057,828027,499460,895888,1012250,192891,230217,273447,900128,758313,433235,778142,970249,651842,82991,260798,1033168,931428,75694,743225,602146,457210,840411,947860,942453,1026979,157130,799055,353513,66669,94228,1044455,214516,763911,1041304,532569,899766,910050,458039,69228,386423,160187,18148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001955s ]