SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490574 LIMIT 1 [ RunTime:0.001074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490574 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122011,927969,764923,422736,129622,491538,461457,383203,827887,564271,180688,691611,465822,607227,315240,190947,708018,996943,764168,364290,150091,679257,323498,464533,364734,221875,228305,819286,48604,245002,774465,20216,791835,935998,171317,204088,332534,476845,442235,67781,476308,1012582,361223,922070,473133,464089,867153,133742,1030312,141709,437544,233770,596765,140898,255676,542218,188801,704785,286341,792562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]