SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340211 LIMIT 1 [ RunTime:0.000719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340211 [ RunTime:0.003227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518943,100694,313149,519834,423860,272709,344817,133579,809843,752011,752446,425563,636733,433267,34767,875500,926873,395919,746248,634179,154956,91811,831213,173417,1001727,41187,550194,740726,873095,858880,404114,933499,349505,154286,930110,89759,968243,990703,170543,326836,332160,395601,398352,913010,882803,214832,492843,772497,146319,833683,524992,421431,863208,531674,473166,988955,569965,497930,388127,187605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]