SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528198 LIMIT 1 [ RunTime:0.001053s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528198 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614913,359355,1011398,1012141,855032,107335,11608,394521,810315,198195,898205,1025181,223532,413947,1027331,549231,1018319,576920,159273,375336,1004992,295518,844274,1027238,930003,322681,12104,1032244,407183,7574,372146,645675,1014657,365767,33684,696190,55239,1047775,960085,550967,931168,382178,784876,927323,212103,575765,581085,686783,491411,26533,162532,208778,46889,49639,664472,498254,890413,552298,523170,1002981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001085s ]