SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339843 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339843 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146201,14563,200822,678116,924960,1044484,992797,219979,556613,40950,705900,493886,973909,418905,492691,540891,770019,555434,241951,1007131,842260,215780,126947,530651,967319,321718,830388,540418,485641,887200,728615,548259,707811,418396,1048890,659574,781423,836333,230737,261045,86931,213370,194229,373731,819941,876705,187946,214014,688178,800796,96493,130197,721052,392780,9623,443068,435387,262042,809398,689542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]