SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045987 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045987 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433169,698505,696015,789721,283342,705468,215282,820914,276275,259012,932392,889241,744862,651576,437778,519575,435913,971847,587947,196705,688504,282726,340765,372081,1001315,213753,107681,224687,975275,380931,752090,898450,64021,782152,107915,772777,37861,1019520,495336,866384,303417,306858,595338,559512,611806,1024074,174352,461116,373995,205129,507622,346307,251783,709032,928974,288714,155179,370079,1047222,242048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]