SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704110 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704110 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18491,655103,700567,715808,807081,303156,391498,165623,150654,1017696,861152,217289,268100,255933,337109,38756,278044,472346,871255,369099,850158,587235,91639,995532,197378,456673,881956,212521,326302,871148,480794,399766,132308,731191,675411,852712,399243,999141,425508,715748,95352,727678,601722,191726,522407,452102,921363,405872,735011,1024148,1010331,342929,471473,762846,583781,535909,383176,237910,265230,303217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]