SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 257582 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 257582 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358482,400103,339686,295145,741281,459296,897482,935214,261824,142579,823380,801972,158661,944793,425465,332421,94372,474217,979758,749665,900658,379176,809605,31081,149742,960771,581053,491752,1020092,833400,216853,166080,705578,470823,620182,17536,730061,543046,656874,358589,995772,900805,1043752,389101,1010425,1039133,149388,990061,255782,940727,505550,157550,779357,320447,988831,740428,846496,412644,384453,407674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 257582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 257582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]