SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33100 LIMIT 1 [ RunTime:0.002968s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33100 [ RunTime:0.002542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25066,775404,1044998,512768,401928,92209,239870,583847,186666,178080,43376,13263,605730,751163,188072,878570,757727,204328,50475,85460,115031,539914,729276,179348,726357,334065,41745,990381,755401,863544,233266,767956,399057,645227,346029,878252,263203,900241,878871,331299,26306,811440,1018440,951928,310334,479170,288373,251864,364906,757051,320055,957437,568470,129437,689105,463092,1006391,199535,907740,397733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]