SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504711 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504711 [ RunTime:0.002675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61154,597769,203591,341634,516713,698626,418427,1030184,294047,877248,128173,95864,337906,1044297,388689,677772,1024769,452773,815213,345359,771596,428558,326636,365612,522091,643343,622226,290769,370845,635972,832850,896261,785796,478928,124162,240142,198035,81968,622074,357733,391638,895279,425171,616017,238329,607860,632058,846977,394814,929039,372116,705242,994617,113203,138347,238149,983432,15296,292260,299334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]