SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814063 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814063 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248028,444163,257944,551210,917581,477097,896967,488754,545326,440340,922178,341334,722965,154073,596638,187694,471644,75094,192048,719697,191740,847021,109975,928644,604567,127424,44104,915134,277213,298978,856653,279310,295396,813170,904279,184513,781466,632282,280851,159148,363126,312250,988409,444760,874836,1015471,496235,435737,381760,210522,412339,862013,745075,1020926,405400,481674,848120,241915,536722,878564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]