SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543138 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543138 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540754,664938,142160,382203,610840,313104,732741,707011,650415,975247,676407,526046,282416,463961,296573,803251,540817,975284,830152,297521,329999,427636,104541,119411,644733,540972,232254,798559,796508,317415,635721,894143,156938,289278,796877,525531,71205,977096,618627,736004,89465,551,368773,286114,770866,743662,134539,926070,410506,213586,296570,775695,85296,527925,421288,867729,536239,228511,774769,583699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]