SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026687 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026687 [ RunTime:0.005297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233885,892805,576327,557269,883806,138953,953569,777625,662328,25134,209606,851493,996699,821769,602189,53999,594200,701820,41850,744607,925024,407928,451808,705876,928332,710194,648909,65381,874503,400121,840376,202798,873488,644588,967180,852965,994640,1040637,129498,337723,151704,456932,133405,385094,913544,237472,607491,947209,1021850,501403,17060,826906,374464,530897,795367,76221,257485,688310,151516,466285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005742s ]