SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194010 LIMIT 1 [ RunTime:0.000693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194010 [ RunTime:0.002206s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419215,1009030,362974,511126,98713,944002,661840,474759,567917,380591,718152,895575,63919,273610,714710,462686,893179,773008,818026,607641,927517,445591,354781,21128,396981,113657,1002297,125719,644093,315426,364497,1015582,732960,862116,321013,996246,832789,456957,669061,638580,284214,808227,958851,635228,458767,538367,640667,551243,475182,352712,355205,219024,1037126,567698,386597,163095,519660,646864,934896,952468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]