SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 230943 LIMIT 1 [ RunTime:0.002513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 230943 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419680,732123,985908,154798,756490,439864,405730,687967,552473,833907,563672,462677,806494,912466,484990,631497,489780,832052,343893,962460,133440,894706,582510,212990,675366,981788,917886,492718,630151,418731,305667,980243,589298,51384,765783,981274,304236,945613,544511,390625,360680,783116,116064,973347,831272,269367,496081,97748,393860,418084,680128,600547,651433,432685,312544,265899,833196,516498,581753,810001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 230943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 230943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001349s ]