SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046284 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046284 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15689,375019,688837,723640,148683,281483,701538,253965,453766,374310,47055,34280,1039789,110782,966819,177441,988701,365892,313555,1014124,885934,308380,363435,961369,72976,976920,512760,160419,951424,44982,332415,152186,868607,829428,828156,448661,397423,648091,542089,1032989,876045,1030754,555070,1048320,37716,124850,88614,1029764,815953,962996,372002,545035,30080,556452,78773,481515,219966,399813,456050,621151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]