SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251988 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251988 [ RunTime:0.003394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264084,11694,1002490,473604,1040198,193488,816924,562227,338500,657584,1014489,115581,1020286,628325,285862,103527,525139,486924,589001,269348,905029,23900,818827,1002710,1039373,701866,44387,751657,329434,687786,543628,185737,113450,842683,9084,862986,307286,583873,59135,528078,98122,812944,490951,956760,312610,583564,280812,841188,651829,1029010,905671,278825,428940,173947,314660,494593,800643,746577,455194,996099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]