SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490481 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490481 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202344,996095,725918,1038147,936465,349021,1031080,385285,1044658,68891,854641,966148,616609,943762,408264,463467,930851,1046858,852002,148423,467661,854719,856523,61986,1004086,130305,602983,811851,448073,767007,572680,332486,184686,930886,1003736,773772,854334,461471,1043547,413160,620261,848782,48789,631595,213952,277697,917958,1017270,1029185,195355,384224,171738,252067,404244,1026380,615137,303416,345715,411096,848180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]