SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531941 LIMIT 1 [ RunTime:0.000609s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531941 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922490,886088,114277,220100,715493,303998,711858,974675,809621,951425,537237,326834,565407,517664,269642,119983,1002963,785372,700691,487881,857758,106000,251800,674456,328331,991826,284958,512174,576581,215347,558588,42942,848364,509507,518578,821794,119224,213666,834817,20358,489974,394765,667572,321878,179884,503282,466793,199986,115083,291587,954873,755200,282385,824459,327375,314408,639341,545219,62602,810828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]