SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334005 LIMIT 1 [ RunTime:0.000892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334005 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141361,622968,766345,295757,971467,752000,918682,500066,309881,252994,366269,803179,418915,688719,595203,340451,503317,311278,651102,533695,98809,60791,322034,749738,163598,761310,603168,393874,922057,841962,829063,862450,690219,646513,103515,941536,667017,313727,356312,997139,262730,769860,993890,189441,280318,712781,316708,536171,590733,515746,188233,215145,785404,201012,530293,82882,885506,874817,758714,324076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]