SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045426 LIMIT 1 [ RunTime:0.000628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045426 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90424,217127,713183,102793,862114,17343,954587,153962,738093,1028734,929786,618364,553131,699236,665348,994644,534234,279458,710223,614787,971594,597760,406727,424000,1008080,956583,661930,611348,153477,608632,887017,915966,336973,258850,224084,46749,169875,84918,117904,92791,485699,981760,111619,60917,831831,565368,8882,457710,810476,55751,813110,147588,390673,21769,306570,441655,514820,214809,414272,8272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]