SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103043 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103043 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545270,584118,639593,733353,760157,299688,531508,852391,71160,528399,445504,1013076,261027,796784,252915,320920,470066,465455,26307,18043,989221,110358,924926,38839,799803,313925,166482,806897,627832,46001,1037356,619939,281933,357424,565345,238087,430246,835643,498146,660567,83554,337490,1029552,11184,594319,119034,339536,39346,150766,953110,4885,95713,862122,283912,801538,100638,958611,3271,92556,514401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]