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` = 281990 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281990 [ RunTime:0.003196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46007,375531,227318,703454,601996,588438,317517,98126,451980,860540,400225,615791,344214,273299,35015,463513,519987,933636,24970,7909,855626,201662,306964,39843,159606,737718,379600,418568,643354,825675,653749,37800,496504,249493,1011867,72857,387613,377561,832897,185025,775270,316416,992045,1023007,462061,132995,65296,875072,198700,603993,201305,565476,190968,804982,887452,643000,106545,97080,276605,163678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]