SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336218 LIMIT 1 [ RunTime:0.001531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336218 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284467,933086,760569,563015,951464,510998,928101,582807,265007,542288,306279,186736,535025,502010,936346,959111,131863,584161,112052,840619,506482,391327,207790,710492,194041,953218,205393,246318,527219,62793,637082,607143,438432,813893,620659,110000,454953,338282,499014,1043365,663460,1039270,649516,763201,229439,371263,597324,383102,565140,579719,441153,379044,476667,388574,754040,886726,685999,512149,804636,788556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]