SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028240 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028240 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58298,1002802,961279,80374,676457,338948,957054,976161,839838,1023453,482313,53167,221939,517360,307171,1035492,435391,288294,772569,452163,6029,242626,543652,883681,835614,698119,808931,506909,684617,218071,37442,395472,49748,595765,176272,561644,295886,87387,880785,636155,291322,814501,902630,622679,931248,591129,462287,471181,70111,518724,908777,4449,248458,631959,53282,371739,576829,993874,742533,988547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]