SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135159 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135159 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901152,269087,303500,705266,461004,114953,1010283,1043909,791231,534435,943587,1012383,194770,300012,239971,841241,412898,305860,888821,49313,518843,229662,346343,668435,865328,566547,298918,29008,497982,704089,612092,428443,51735,459321,140004,327203,706579,805200,383071,451404,948184,640540,279075,227963,817442,798172,97109,810597,64505,696838,239092,837224,341348,810853,192788,142212,490879,490339,197596,879388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]