SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037408 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037408 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540402,1001259,48888,652983,271198,94084,251768,846943,979522,417168,430229,592479,582933,166264,318063,440553,201807,766997,574272,120309,733585,379267,251043,393304,175187,539325,971035,920686,214805,891341,151216,187680,748541,114349,908184,158707,653287,223932,838139,278744,694053,549280,886709,600451,549450,1002390,774205,803861,668996,359841,265334,686895,634316,670857,814233,1014881,1004913,825532,791463,965786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004853s ]