SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476192 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476192 [ RunTime:0.003708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406833,711648,536177,693144,78144,738354,698686,139520,919089,458829,916984,719212,682895,505282,96042,126651,227401,832398,840218,872440,99012,1027708,125578,149544,114415,28338,754293,259390,276154,979531,529485,880458,432064,195218,266524,287788,965369,267494,613899,180857,903685,340266,750762,234677,892287,880484,176469,519020,597897,387638,190829,372699,22702,462169,348992,269004,273274,921934,616788,129843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001793s ]