SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196816 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196816 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566461,810304,570440,48005,266280,476318,902247,714309,466270,795529,54573,341749,182880,742383,278630,815110,185339,913587,257819,474519,269495,207172,379644,370529,593993,621993,532486,693755,1041274,586829,231868,803648,1022523,439779,1037449,239223,171105,1011792,1009163,427041,159309,538712,936016,663526,554628,443696,124422,788916,784778,688668,484609,635467,812356,158346,9691,522292,396267,1004054,305638,450172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002168s ]